USE [PaltopDatabase]
GO

/****** Object:  View [dbo].[FileAndFolder_View]    Script Date: 11/21/2011 09:05:49 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE VIEW [dbo].[FileAndFolder_View]
AS
SELECT     dbo.FileExtention.FileExtentionID, dbo.FileExtention.Title AS ExtentionTitle, dbo.FileExtention.Description, dbo.FileExtention.JSFunction, dbo.FileInfo.FileInfoID, 
                      dbo.FileInfo.CreationDate, dbo.FileInfo.Title, dbo.FileInfo.RootFolderID, dbo.FileInfo.Size, dbo.FileInfo.ParentID, dbo.FileInfo.FileFlag, dbo.FileInfo.IsRoot, 
                      dbo.FileInfo.Address, dbo.FileSecurityInfo.Access, dbo.FileSecurityInfo.FileSecurityInfoID, dbo.FileSecurityInfo.AccountID
FROM         dbo.FileExtention INNER JOIN
                      dbo.FileInfo ON dbo.FileExtention.FileExtentionID = dbo.FileInfo.FileExtentionID INNER JOIN
                      dbo.FileInfo_FileSecurityInfo ON dbo.FileInfo.FileInfoID = dbo.FileInfo_FileSecurityInfo.FileInfoID INNER JOIN
                      dbo.FileSecurityInfo ON dbo.FileInfo_FileSecurityInfo.FileSecurityInfoID = dbo.FileSecurityInfo.FileSecurityInfoID

GO
